UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sedbXKsP71Rvb1h6UugXY748o7Q1AKifq+pi6SyUsqc='
WHERE
key_id = 'd1972b04841beb0284e25e40583a8a2da37dcc7a0e33a52ebe2fa1f733c1e1e1'
AND (
token = 'sedbXKsP71Rvb1h6UugXY748o7Q1AKifq+pi6SyUsqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)