UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXnMc5wJpmF+oM/GL9x5XbwvdqDXGX5z0MZqz+B48ME='
WHERE
key_id = '4c82fd4d564d220998a1a7de3ebbae0e41666215dc99e8e3a2eeebc6f2e884fe'
AND (
token = 'TXnMc5wJpmF+oM/GL9x5XbwvdqDXGX5z0MZqz+B48ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)