UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'br9cIk3hccgKwhwXShmjI/4uqRkA1Yctctz78vyYndE='
WHERE
key_id = 'e64f993f9c78a31e12cde633a5d06a34bba83bde7acc98bb46bf2bc0a2634c48'
AND (
token = 'br9cIk3hccgKwhwXShmjI/4uqRkA1Yctctz78vyYndE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)