UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a45WXkHWUF0x7ROsHc0jwBQ7e4AWfFZlwgtjH6sw2lw='
WHERE
key_id = 'd1fe5b99d15ff960edc73e90b5844c96cee1c5823f45021f87fcca92fefe438c'
AND (
token = 'a45WXkHWUF0x7ROsHc0jwBQ7e4AWfFZlwgtjH6sw2lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)