UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Khauv1re4M86vnScCE45Rfq7OUQwcBwX2W9B08LRnVE='
WHERE
key_id = '46f823378990bd27f7e4e3992627beaa1c0062cf9f20a8a8e520daabd4f71134'
AND (
token = 'Khauv1re4M86vnScCE45Rfq7OUQwcBwX2W9B08LRnVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)