UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k+ATERB0hoYgxeJUUE9YT43i+OMtb6i8JxCSvk2yuSo='
WHERE
key_id = '5a01178a212e6b8ce8dc03862f1dfdd0290ddc0f13ef1ee9b657f54185e4bd40'
AND (
token = 'k+ATERB0hoYgxeJUUE9YT43i+OMtb6i8JxCSvk2yuSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)