UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dH1bNamAv26IJLHYyLz+oc7W4iz2I/d5quJV+uAs+I='
WHERE
key_id = '6db7f628e9b3edeec9ec2b2185c3ce7a7b0543a02f112801592597c8cb80c69a'
AND (
token = '0dH1bNamAv26IJLHYyLz+oc7W4iz2I/d5quJV+uAs+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)