UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lc0W3XukioA1KyFPCSHT+Fds9IatZbHgEKNG27N7K6I='
WHERE
key_id = '5a75409de670e22777718535957c0ddd068916334167271a9b8e9b0d2988f110'
AND (
token = 'lc0W3XukioA1KyFPCSHT+Fds9IatZbHgEKNG27N7K6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)