UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVqtHpXYiwQa6acn3o9ar5QWuYsaNZ9lDjt0BwBs2PI='
WHERE
key_id = '75746749a8cb5f28a227ed5852119949efe5a622f858c47b9d776c77b4a9f3f1'
AND (
token = 'zVqtHpXYiwQa6acn3o9ar5QWuYsaNZ9lDjt0BwBs2PI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)