UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1haV06fAX/ksofzwcwC4dnT7e4s+2nI7t1RMuIfWhs='
WHERE
key_id = 'f56d71783bb58ae0e79ec55c3410d8ba3a84635cc4c4c15e1a592c80ebc09408'
AND (
token = 'V1haV06fAX/ksofzwcwC4dnT7e4s+2nI7t1RMuIfWhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)