UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5HV0CcbTwjCcWs3mHDhHj+enrDCaSB2524TP0k3jSYk='
WHERE
key_id = '78dd4bb3331f12e303fff2fd25461fdebf688a6eb499cfbfe748c6a2d32569fe'
AND (
token = '5HV0CcbTwjCcWs3mHDhHj+enrDCaSB2524TP0k3jSYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)