UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9gOSw2/82nRj1ezAvOVFFogDJLBRD+PaRn7Yph01jA='
WHERE
key_id = '3cc9a3019ef5d745c1b7b8e5c68c52a1c4716f12bd7764399a7ea37122bf3ff8'
AND (
token = 'S9gOSw2/82nRj1ezAvOVFFogDJLBRD+PaRn7Yph01jA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)