UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3WKt80vYmPbkrlGgE3e9lvh9syj/2XLnKjzuUReZC+M='
WHERE
key_id = 'ca50685123d14563ab55ae88b6343559dcfed39a9685aca4c4f69065b30dffac'
AND (
token = '3WKt80vYmPbkrlGgE3e9lvh9syj/2XLnKjzuUReZC+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)