UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Hw/+0DZcVIGhNsqZ0bD1u8pCzKBq8zUpsHkOA3VjRo='
WHERE
key_id = 'ca364488240f552d4378b02e9953cbe94ca484329f8d03ca710a4daa2e87d0ee'
AND (
token = '3Hw/+0DZcVIGhNsqZ0bD1u8pCzKBq8zUpsHkOA3VjRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)