UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iKhN0VLOiS26bQZZA/LQmnDPDYdkn+vBKzeu7BW34i8='
WHERE
key_id = '28f14a009f8d27eb81338eda950d672c28708b9aadf44df8b1a9f431ea59ef63'
AND (
token = 'iKhN0VLOiS26bQZZA/LQmnDPDYdkn+vBKzeu7BW34i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)