UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZj3jo2+zYFcOb4BGhjn3gjNSEvcoKsHyNyjrThe5UU='
WHERE
key_id = 'dce3ca7d014b6de19c9e8d874cc31cfcced5f94e251c1f6de5352e5cbdbcb596'
AND (
token = 'pZj3jo2+zYFcOb4BGhjn3gjNSEvcoKsHyNyjrThe5UU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)