UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gNHVGiRfVDW21W84cIGwsXPDIveT/f8pCyXWEFXxWMc='
WHERE
key_id = 'd5015463c47619b9287731d13ea834719b356981a8306f9416d54f8e59788c0e'
AND (
token = 'gNHVGiRfVDW21W84cIGwsXPDIveT/f8pCyXWEFXxWMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)