UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ort4qbNnovOzA4nyeA5KI31zG3sgzbPeTpCz54Cxic='
WHERE
key_id = 'f6427b0905143646c30bf275a25bc526f4d8cd96fc5bd68f447053f648de44ea'
AND (
token = '/ort4qbNnovOzA4nyeA5KI31zG3sgzbPeTpCz54Cxic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)