UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MA558M40G2r6JY6E2xUN9g6JH49P0P1lRHeuWGYshMw='
WHERE
key_id = '528783af19897604710c800d1ab4a3bef69ccb561807c23b6487fc64b74cf19a'
AND (
token = 'MA558M40G2r6JY6E2xUN9g6JH49P0P1lRHeuWGYshMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)