UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w0xdcA0nQeiUOir2lsJRO3MA57a3nUq7cj7TSs53Tjo='
WHERE
key_id = 'b23b4a4b1e1b4b318677bcdba556050bf1213c7c2a8e7cec27a67ef3321bce59'
AND (
token = 'w0xdcA0nQeiUOir2lsJRO3MA57a3nUq7cj7TSs53Tjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)