UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ImLAuNdNe4ITfekQqeZlXDRa+rKT6gS7zqI085oPgU='
WHERE
key_id = 'bf135450e83ddfcdf97e27607d12d72e42b3740f34121c0f6f06e0e0cf9a38c4'
AND (
token = '9ImLAuNdNe4ITfekQqeZlXDRa+rKT6gS7zqI085oPgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)