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