UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd+vwsHRCYXkXfsc2V5lkUNE88AJHFPVvwcoiwAB7fx8='
WHERE
key_id = 'e320aa438c8ede2cea1cf9df039b08e41a988f21190447706ab8d306f987d24c'
AND (
token = 'd+vwsHRCYXkXfsc2V5lkUNE88AJHFPVvwcoiwAB7fx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)