UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ghwPnogUQ9EZQD6j6dDVlcwnwOU8pm1Am/y8j7PmCT8='
WHERE
key_id = 'f79884251e9aa9a31734972be7b57d81f528f5f4e5fb84058a187d234e2f138f'
AND (
token = 'ghwPnogUQ9EZQD6j6dDVlcwnwOU8pm1Am/y8j7PmCT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)