UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nMl8PrSC8fw0fIntWGDvRZynvwiU3cDqi6/Robes4UM='
WHERE
key_id = '807ffc4b9a6632358c39e3f44286f7829953335a986e3d8a7072419fa7694a72'
AND (
token = 'nMl8PrSC8fw0fIntWGDvRZynvwiU3cDqi6/Robes4UM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)