UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YTr7r0B/tXaI8wM6T2n+gMzPsiRE+L07E1NthCxK7iQ='
WHERE
key_id = '1194ac477e9090a14ad3debbed4fad6671f0d00444064f18f1e55a772ed0b571'
AND (
token = 'YTr7r0B/tXaI8wM6T2n+gMzPsiRE+L07E1NthCxK7iQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)