UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IoHxEWWYFUCMNwOUZDvWF9/d8218iA/LAKtM5r5e2Vk='
WHERE
key_id = 'a31aebdb58e35403fd29c397efd64bfad6fa91f4a2cd01c248c6d3c166da5fe5'
AND (
token = 'IoHxEWWYFUCMNwOUZDvWF9/d8218iA/LAKtM5r5e2Vk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)