UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBuWU9FqKRGa/y/ktN9y0kgZp3qBasB8sFLmL9YX5pU='
WHERE
key_id = 'ad1dded76d19321d48da7eb1634c04e5da9f4f4d4e5cd51083173023dc295272'
AND (
token = 'KBuWU9FqKRGa/y/ktN9y0kgZp3qBasB8sFLmL9YX5pU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)