UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8D4oZkojlDOmklPhDt/y0zM8JLl0uqrWOuwMLcGrQR8='
WHERE
key_id = 'd15d88a9fb074822ed9a778d856524d73a88786bf1d6012b1ab8a0069d22394c'
AND (
token = '8D4oZkojlDOmklPhDt/y0zM8JLl0uqrWOuwMLcGrQR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)