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