UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1WG5byQtPg5uNFtOepvtQQByFbN3vbLr11c4N7onAk='
WHERE
key_id = 'c3cf53866291c92aa6b94114d384cae93178b96671ebd71102a0eff5f73208a7'
AND (
token = 'N1WG5byQtPg5uNFtOepvtQQByFbN3vbLr11c4N7onAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)