UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qLpJ00KE5UEGC5w8N8xz9Sy2Peb0hazCXHTenfBus3o='
WHERE
key_id = '831b4fa3bd3e70bd8029c43ba64d98c8d811c8a2100541899d79e218662076c0'
AND (
token = 'qLpJ00KE5UEGC5w8N8xz9Sy2Peb0hazCXHTenfBus3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)