UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+h1oFMB4uTUyn/R+yPBA0AbNFo4H8XtRZC01S+yx4o='
WHERE
key_id = 'bb76c5bf41835f36a78fb4744b7f8769816d38e5c9ef37fd2e4fab619bedfe5b'
AND (
token = 'X+h1oFMB4uTUyn/R+yPBA0AbNFo4H8XtRZC01S+yx4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)