UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZTyCi+D7tkI9fZXuymzBqgmoF8a1FqgKVuPunFhKeU='
WHERE
key_id = 'bdbdeac081a1c2efb28e55a2add325d1c1f9b5199901b4de51ebcc98990ed301'
AND (
token = 'gZTyCi+D7tkI9fZXuymzBqgmoF8a1FqgKVuPunFhKeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)