UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't7kmwZautjcaPLIO7KH7j0LReH1vCCpbK05AYxhGpEQ='
WHERE
key_id = '40cc97ea3a355b53eb7e37cc47fbd8fe9186d12e4b0744729c204cc14d538b4a'
AND (
token = 't7kmwZautjcaPLIO7KH7j0LReH1vCCpbK05AYxhGpEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)